Tabela CO_CATERINGORDERITEM

Definicja tabeli CO_CATERINGORDERITEM

Name

CO_CATERINGORDERITEM

Code

CO_CATERINGORDERITEM

Comment

 


Lista kolumn tabeli CO_CATERINGORDERITEM

Name

Code

CO_CATERINGORDERITEMID

CO_CATERINGORDERITEMID

CO_CATERINGORDERID

CO_CATERINGORDERID

TYPE

TYPE

CO_RECIPEID

CO_RECIPEID

NAME

NAME

QUANTITY

QUANTITY

PRICENETTO

PRICENETTO

VATRATE

VATRATE

COMMENTS

COMMENTS

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_CATERINGORDERITEMID tabeli CO_CATERINGORDERITEM

Definicja kolumny CO_CATERINGORDERITEMID tabeli CO_CATERINGORDERITEM

Name

CO_CATERINGORDERITEMID

Code

CO_CATERINGORDERITEMID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CO_CATERINGORDERID tabeli CO_CATERINGORDERITEM

Definicja kolumny CO_CATERINGORDERID tabeli CO_CATERINGORDERITEM

Name

CO_CATERINGORDERID

Code

CO_CATERINGORDERID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TYPE tabeli CO_CATERINGORDERITEM

Definicja kolumny TYPE tabeli CO_CATERINGORDERITEM

Name

TYPE

Code

TYPE

Data Type

VARCHAR2(20)

Mandatory

Yes

Comment

 


Kolumna CO_RECIPEID tabeli CO_CATERINGORDERITEM

Definicja kolumny CO_RECIPEID tabeli CO_CATERINGORDERITEM

Name

CO_RECIPEID

Code

CO_RECIPEID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NAME tabeli CO_CATERINGORDERITEM

Definicja kolumny NAME tabeli CO_CATERINGORDERITEM

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna QUANTITY tabeli CO_CATERINGORDERITEM

Definicja kolumny QUANTITY tabeli CO_CATERINGORDERITEM

Name

QUANTITY

Code

QUANTITY

Data Type

NUMBER(19,3)

Mandatory

Yes

Comment

 


Kolumna PRICENETTO tabeli CO_CATERINGORDERITEM

Definicja kolumny PRICENETTO tabeli CO_CATERINGORDERITEM

Name

PRICENETTO

Code

PRICENETTO

Data Type

NUMBER(19,2)

Mandatory

Yes

Comment

 


Kolumna VATRATE tabeli CO_CATERINGORDERITEM

Definicja kolumny VATRATE tabeli CO_CATERINGORDERITEM

Name

VATRATE

Code

VATRATE

Data Type

NUMBER

Mandatory

No

Comment

 


Kolumna COMMENTS tabeli CO_CATERINGORDERITEM

Definicja kolumny COMMENTS tabeli CO_CATERINGORDERITEM

Name

COMMENTS

Code

COMMENTS

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna INSERTDATE tabeli CO_CATERINGORDERITEM

Definicja kolumny INSERTDATE tabeli CO_CATERINGORDERITEM

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_CATERINGORDERITEM

Definicja kolumny INSERTINGPERSON tabeli CO_CATERINGORDERITEM

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_CATERINGORDERITEM

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_CATERINGORDERITEM

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_CATERINGORDERITEM

Definicja kolumny LASTMODIFIEDDT tabeli CO_CATERINGORDERITEM

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_CATERINGORDERITEM

Name

Code

Primary

PK_CO_CATERINGORDERITEM

PK_CO_CATERINGORDERITEM

X


Klucz PK_CO_CATERINGORDERITEM tabeli CO_CATERINGORDERITEM

Definicja klucza PK_CO_CATERINGORDERITEM tabeli CO_CATERINGORDERITEM

Name

PK_CO_CATERINGORDERITEM

Code

PK_CO_CATERINGORDERITEM

Primary

Yes

Comment